RSVP for the PSU Professional Development Center Info Session on February 24, 5-7pm. Bryan Rhoads, Internet Strategy workshop instructor, will give a brief presentation on social media marketing. The Multimedia Professional Program will be featured and participants will be able to interact with program managers on certificates, workshops and courses available.

5:00 - Check In

5:30 - Introduction by Professional Development Center (PDC)

5:35 - Presentations

         Room 1050C: Brian Rhoades
         Room 1053: Jennifer Johnson

5:50 - Break for refreshments/Questions

6:00 – Roundtable Discussions

         Room 1050C
         Professional Writing
         Multimedia
         Information Technology

         Room 1053
         Healthcare Management
         Six Sigma
         Human Resource Management

6:20 - Break for refreshments

6:30 – Roundtable Discussions

         Room 1050C
         Current Topics & Contemporary Issues
         Organization Development

         Room 1053
         Project Management
         Accelerated Supervision
         Marketing

6:50 - Reconvene, questions

About the Workshop: The twenty first century is a knowledge worker driven era. New methods of managing acquiring, nurturing and retaining talent will be essential for a competitive organization. In this half-day workshop, a series of presenters will bring tools every HR leader should have in their toolkit and executive should hear.

Session 1 (8:00 – 9:00 a.m.): From Start-Up to High-Growth: Shaping a Culture for Success The shift from a start-up culture has caused many promising companies to stumble. EthicsPoint president and CEO David Childers will present the step-by-step process his company took to consciously reconstruct its corporate culture. This two-year-long project has helped EthicsPoint exceed growth and revenue expectations and position itself for international expansion.

Session 2 (9:00 – 10:00 a.m.) Turning the Job They Have Into the Job They Want For many companies the downturn has stalled growth, which in turn has left employees feeling “stuck” in their jobs. This dissatisfaction can be especially difficult in technology companies where employees are attracted to working fast paced growth and changing environments. Via Skype, Dr. Jane Dutton from University of Michigan will share the Job Crafting Exercise, a low cost, powerful tool that the Center for Positive Organizational Scholarship has developed.

Session 3 (10:15 – 11:15 a.m.) Performance Appraisals – The Next Act Few issues in management stir up more controversy than performance appraisal.

There are many reputable sources - researchers, management commentators, psychometricians - who have expressed doubts about the validity and reliability of the performance appraisal process. Some have even suggested that the process is so inherently flawed that it may be impossible to perfect it. At the other extreme, there are many strong advocates of performance appraisal. Some view it as potentially the most crucial aspect of organizational life (Lawrie, 1990). Dr. Steve Hunt will talk about how the performance management process is shifting from an administrative process used to justify pay decisions to a forward focused tool for enabling business execution.

Complete workshop information can be found here: http://www.techamerica.org/talentmanagementworkshop

Details: When: Thursday, September 30, 2010 Time: 7:30 – 11:30 a.m. Where: Multnomah Athletic Club, 1849 SW Salmon St., Portland, Ore. Cost: $195 TechAmerica Members, $225 Nonmembers (Group rates available - email [email protected] for details)

Want to take your career to the next level?

Practical, Hands-on Training for Advanced Excel Formulas & Functions

Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale, “ 80 percent of job openings require spreadsheet and word-processing software skills. Yet so many people never even give Excel a chance because it has an intimidating stigma around it.”

If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product profesionals using Excel to list customer and sales targets; managing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand.In essence, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view.

STRUCTURE OF COURSE

Advanced functions and formulas

 *Logical functions
 *Conditional functions
 *Financial functions
 *Text functions
 *Date functions
 *Array formulas

Lookups and data tables

 *Using lookup functions
 *Using MATCH and INDEX
 *Creating data tables

Advanced data management

 *Validating cell entries
 *Advanced filtering

Advanced charting

 *Chart formatting options
 *Combination charts
 *Graphical objects

PivotTables and PivotCharts

 *Working with PivotTables
 *Rearranging PivotTables
 *Formatting PivotTables
 *PivotCharts

Exporting and Importing Data

 *Exporting and importing text files
 *Getting external data

Analytical Tools

 *Goal Seek
 *Scenarios

Macros and Visual Basic

 *Running and recording a macro
 *Working with VBA code

ABOUT THE INSTRUCTOR

Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.

BENEFITS

Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

MAKE YOUR RESUME STAND OUT

They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your ability to an employer then writing Excel. Someone who writes VLOOKUP, Pivot Table, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence, use actual Excel functions in your Resume!

INCREASE YOUR EARNING POTENTIAL

Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical. Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.

INSPIRING ENTREPRENEUR?

A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy? Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.

WHO SHOULD COME?

People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.

ADDITIONAL BENEFITS?

FOR FURTHER INFORMATION: PLEASE CONTACT US AT [email protected].

SOLD OUT?

This is one of our high demand classes. In the case, we sale out; email us at [email protected] and ask when our next course will be in